CREATE TABLE all_types(
  some_tiny_int TINYINT,
  some_small_int SMALLINT,
  some_medium_int MEDIUMINT,
  some_integer INTEGER,
  some_int INT,
  some_big_int BIGINT,
  some_decimal DECIMAL,
  some_dec DEC,
  some_fixed FIXED,
  some_numeric NUMERIC,
  some_float FLOAT,
  some_real REAL,
  some_double_precision DOUBLE PRECISION,
  some_double DOUBLE,
  some_date DATE,
  some_time TIME,
  some_datetime DATETIME,
  some_timestamp TIMESTAMP,
  some_year YEAR,
  some_char CHAR,
  some_varchar VARCHAR(16),
  some_tiny_text TINYTEXT,
  some_text TEXT,
  some_medium_text MEDIUMTEXT,
  some_long_text LONGTEXT,
  some_enum ENUM,
  some_set SET,
  some_varbinary VARBINARY(8),
  some_blob BLOB(8, 8),
  some_binary BINARY,
  some_json JSON,
  some_boolean BOOLEAN,
  some_bit BIT(1),
  some_mediumblob MEDIUMBLOB
);
